Formulas: Start with an equal sign (=) and can perform calculations, such as =A1+B1 for addition.
Basic Functions: Excel has built-in functions like SUM, AVERAGE, MIN, and MAX. For example, =SUM(A1:A10) adds up all the values in the range.
Logical Functions: These include functions like IF, AND, and OR. For example, =IF(A1>10, "Yes", "No") returns "Yes" if A1 is greater than 10, otherwise "No".
Date and Time Functions: Includes NOW(), TODAY(), YEAR(), and MONTH(), allowing you to work with dates and times.
Text Functions: Functions like CONCATENATE, LEFT, RIGHT, and LEN help manipulate text within cells.
Lookup Functions: Includes VLOOKUP, HLOOKUP, INDEX, and MATCH, which help retrieve data from a specific part of a worksheet based on criteria.
HLOOKUP: This function searches for a value in the top row of a range and returns a value in the same column from a row you specify. The syntax is =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]).